package com.hwua.tonyshop.criteria;
	
import com.slkj.autocode.entity.Page;
import com.hwua.tonyshop.entity.pojo.User;

/**
* 
* @author sunny Yang [杨松彦]
* @QQ 550358261
* @date 2018-04-16
* @discribe
* >、<、>=、<=、=、!=、like、
* is null、is not null、in、not in
*
*/
public class UserCriteria extends User{
	/**
	* 版本号
	*/
	private static final long serialVersionUID = 1L;
	private String groupBy123;//分组
	private String having123;//分组过滤
	private String orderBy123;//排序
	private Page page123;
	private String condition123="";//纯条件
	private String selectCondition123;//查询条件
	private String sql123;
	private User user;
	private String feid123;//字段用于统计查询时设置

	public UserCriteria() {

	}
	public String getFeid123() {
		return feid123;
	}
	public void setFeid123(String feid) {
		this.feid123 = feid;
	}
	public User getUser() {
		return user;
	}
	public void setUser(User user) {
		this.user = user;
		initUser(user);
	}

	public String getSql123() {
		return sql123;
	}

	public void setSql123(String sql123) {
		this.sql123 = sql123;
	}

	public String getSelectCondition123() {
		if(selectCondition123==null){
			if(condition123.trim().length()>0){
				condition123 = "where "+condition123;
			}
			selectCondition123 = condition123;
			if(groupBy123!=null){
				selectCondition123 += " group by "+groupBy123+" ";
			}
			if(having123!=null){
				selectCondition123 += "having "+having123+" ";
			}
			if(orderBy123!=null){
				selectCondition123 += "order by "+orderBy123+" ";
			}
			if(page123!=null){
				selectCondition123 += "limit "+((page123.getPageNumber()-1)*page123.getPageSize())+","+page123.getPageSize();
			}
			selectCondition123 = selectCondition123.trim();
		}
		System.out.println("查询条件："+selectCondition123);
		return selectCondition123;
	}
	public void setSelectCondition123(String selectCondition) {
		this.selectCondition123 = selectCondition;
	}
	public String getCondition123() {
		System.out.println("纯条件："+condition123);
		return condition123;
	}
	public void setCondition123(String condition) {
		this.condition123 = condition;
	}
	public UserCriteria page(Page value){
		page123 = value;
		return this;
	}
	public UserCriteria groupBy(String value){
		groupBy123 = value;
		return this;
	}
	public UserCriteria having(String value){
		having123 = value;
		return this;
	}
	public UserCriteria orderBy(String value){
		orderBy123 = value;
		return this;
	}

	/*public String getSqlAll(String tableName){
		String sql = "";
		if("where ".equals(condition123)){
			sql = "select * from `"+tableName+"` ";
		}else{
			sql = "select * from `"+tableName+"` "+condition123+" ";
		}
		if(groupBy123!=null){
			sql += sql+" group by "+groupBy123+" ";
		}
		if(having123!=null){
			sql += "having "+having123+" ";
		}
		if(orderBy123!=null){
			sql += "order by "+orderBy123+" ";
		}
		if(page123!=null){
			sql += "limit "+((page123.getPageNumber()-1)*page123.getPageSize())+","+page123.getPageSize();
		}
		sql = sql.trim();
		return sql; 
	}*/

/************以下为纯条件的拼接*******************/

	public UserCriteria andIdEquals(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "and `id`="+id+" ";
			}else{
				condition123 += "`id`="+id+" ";
			}
		}
		return this;
	}
	
	public UserCriteria orIdEquals(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "or `id`="+id+" ";
			}else{
				condition123 += "`id`="+id+" ";
			}
		}
		return this;
	}
	
	public UserCriteria andIdNotEquals(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "and `id`!="+id+" ";
			}else{
				condition123 += "`id`!="+id+" ";
			}
		}
		return this;
	}
	public UserCriteria orIdNotEquals(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "or `id`!="+id+" ";
			}else{
				condition123 += "`id`!="+id+" ";
			}
		}
		return this;
	}
	/**
	 * 大于
	 * @param 
	 * @return
	 */
	public UserCriteria andIdGreaterThan(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "and `id`>"+id+" ";
			}else{
				condition123 += "`id`>"+id+" ";
			}
		}
		return this;
	}
	public UserCriteria orIdGreaterThan(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "or `id`>"+id+" ";
			}else{
				condition123 += "`id`>"+id+" ";
			}
		}
		return this;
	}
	
	
	public UserCriteria andIdLessThan(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "and `id`<"+id+" ";
			}else{
				condition123 += "`id`<"+id+" ";
			}
		}
		return this;
	}
	public UserCriteria orIdLessThan(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "or `id`<"+id+" ";
			}else{
				condition123 += "`id`<"+id+" ";
			}
		}
		return this;
	}
	
	public UserCriteria andIdGreadterThanAndEquals(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "and `id`>="+id+" ";
			}else{
				condition123 += "`id`>="+id+" ";
			}
		}
		return this;
	}
	public UserCriteria orIdGreadterThanAndEquals(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "or `id`>="+id+" ";
			}else{
				condition123 += "`id`>="+id+" ";
			}
		}
		return this;
	}
	
	public UserCriteria andIdLessThanAndEquals(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "and `id`<="+id+" ";
			}else{
				condition123 += "`id`<="+id+" ";
			}
		}
		return this;
	}
	public UserCriteria orIdLessThanAndEquals(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "or `id`<="+id+" ";
			}else{
				condition123 += "`id`<="+id+" ";
			}
		}
		return this;
	}
	
	public UserCriteria andIdLike(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "and `id` like "+id+" ";
			}else{
				condition123 += "`id` like "+id+" ";
			}
		}
		return this;
	}
	public UserCriteria orIdLike(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "or `id` like "+id+" ";
			}else{
				condition123 += "`id` like "+id+" ";
			}
		}
		return this;
	}
	
	public UserCriteria andIdIsNull(){
			if(condition123.length()>0){
				condition123 += "and `id` is null";
			}else{
				condition123 += "`id` is null";
			}
		return this;
	}
	public UserCriteria orIdIsNull(){
		if(condition123.length()>0){
			condition123 += "or `id` is null";
		}else{
			condition123 += "`id` is null";
		}
		return this;
	}
	public UserCriteria andIdIsNotNull(){
		if(condition123.length()>0){
			condition123 += "and `id` is not null";
		}else{
			condition123 += "`id` is not null";
		}
		return this;
	}
	public UserCriteria orIdIsNotNull(){
		if(condition123.length()>0){
			condition123 += "or `id` is not null";
		}else{
			condition123 += "`id` is not null";
		}
		return this;
	}
	public UserCriteria andIdIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `id` in("+value+") ";
			}else{
				condition123 += "`id` in("+value+") ";
			}
		}
		return this;
	}
	public UserCriteria orIdIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `id` in("+value+") ";
			}else{
				condition123 += "`id` in("+value+") ";
			}
		}
		return this;
	}
	public UserCriteria andIdNotIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `id` not in("+value+") ";
			}else{
				condition123 += "`id` not in("+value+") ";
			}
		}
		return this;
	}
	public UserCriteria orIdNotIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `id` not in("+value+") ";
			}else{
				condition123 += "`id` not in("+value+") ";
			}
		}
		return this;
	}

	public UserCriteria andUserNameEquals(String userName){
		if(userName!=null&&userName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `user_name`='"+userName+"' ";
			}else{
				condition123 += "`user_name`='"+userName+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria orUserNameEquals(String userName){
		if(userName!=null&&userName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `user_name`='"+userName+"' ";
			}else{
				condition123 += "`user_name`='"+userName+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andUserNameNotEquals(String userName){
		if(userName!=null&&userName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `user_name`!='"+userName+"' ";
			}else{
				condition123 += "`user_name`!='"+userName+"' ";
			}
		}
		return this;
	}
	public UserCriteria orUserNameNotEquals(String userName){
		if(userName!=null&&userName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `user_name`!='"+userName+"' ";
			}else{
				condition123 += "`user_name`!='"+userName+"' ";
			}
		}
		return this;
	}
	/**
	 * 大于
	 * @param 
	 * @return
	 */
	public UserCriteria andUserNameGreaterThan(String userName){
		if(userName!=null&&userName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `user_name`>'"+userName+"' ";
			}else{
				condition123 += "`user_name`>'"+userName+"' ";
			}
		}
		return this;
	}
	public UserCriteria orUserNameGreaterThan(String userName){
		if(userName!=null&&userName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `user_name`>'"+userName+"' ";
			}else{
				condition123 += "`user_name`>'"+userName+"' ";
			}
		}
		return this;
	}
	
	
	public UserCriteria andUserNameLessThan(String userName){
		if(userName!=null&&userName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `user_name`<'"+userName+"' ";
			}else{
				condition123 += "`user_name`<'"+userName+"' ";
			}
		}
		return this;
	}
	public UserCriteria orUserNameLessThan(String userName){
		if(userName!=null&&userName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `user_name`<'"+userName+"' ";
			}else{
				condition123 += "`user_name`<'"+userName+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andUserNameGreadterThanAndEquals(String userName){
		if(userName!=null&&userName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `user_name`>='"+userName+"' ";
			}else{
				condition123 += "`user_name`>='"+userName+"' ";
			}
		}
		return this;
	}
	public UserCriteria orUserNameGreadterThanAndEquals(String userName){
		if(userName!=null&&userName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `user_name`>='"+userName+"' ";
			}else{
				condition123 += "`user_name`>='"+userName+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andUserNameLessThanAndEquals(String userName){
		if(userName!=null&&userName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `user_name`<='"+userName+"' ";
			}else{
				condition123 += "`user_name`<='"+userName+"' ";
			}
		}
		return this;
	}
	public UserCriteria orUserNameLessThanAndEquals(String userName){
		if(userName!=null&&userName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `user_name`<='"+userName+"' ";
			}else{
				condition123 += "`user_name`<='"+userName+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andUserNameLike(String userName){
		if(userName!=null&&userName.trim().length()>0&&!("%".equals(userName.trim()))&&!("%%".equals(userName.trim()))){
			if(condition123.length()>0){
				condition123 += "and `user_name` like '"+userName+"' ";
			}else{
				condition123 += "`user_name` like '"+userName+"' ";
			}
		}
		return this;
	}
	public UserCriteria orUserNameLike(String userName){
		if(userName!=null&&userName.trim().length()>0&&!("%".equals(userName.trim()))&&!("%%".equals(userName.trim()))){
			if(condition123.length()>0){
				condition123 += "or `user_name` like '"+userName+"' ";
			}else{
				condition123 += "`user_name` like '"+userName+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andUserNameIsNull(){
			if(condition123.length()>0){
				condition123 += "and `user_name` is null";
			}else{
				condition123 += "`user_name` is null";
			}
		return this;
	}
	public UserCriteria orUserNameIsNull(){
		if(condition123.length()>0){
			condition123 += "or `user_name` is null";
		}else{
			condition123 += "`user_name` is null";
		}
		return this;
	}
	public UserCriteria andUserNameIsNotNull(){
		if(condition123.length()>0){
			condition123 += "and `user_name` is not null";
		}else{
			condition123 += "`user_name` is not null";
		}
		return this;
	}
	public UserCriteria orUserNameIsNotNull(){
		if(condition123.length()>0){
			condition123 += "or `user_name` is not null";
		}else{
			condition123 += "`user_name` is not null";
		}
		return this;
	}
	
	public UserCriteria andUserNameIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `user_name` in("+value+") ";
			}else{
				condition123 += "`user_name` in("+value+") ";
			}
		}
		return this;
	}
	
	public UserCriteria orUserNameIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `user_name` in("+value+") ";
			}else{
				condition123 += "`user_name` in("+value+") ";
			}
		}
		return this;
	}
	
	public UserCriteria andUserNameNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `user_name` not in("+value+") ";
			}else{
				condition123 += "`user_name` not in("+value+") ";
			}
		}
		return this;
	}
	
	public UserCriteria orUserNameNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `user_name` not in("+value+") ";
			}else{
				condition123 += "`user_name` not in("+value+") ";
			}
		}
		return this;
	}

	public UserCriteria andPasswordEquals(String password){
		if(password!=null&&password.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `password`='"+password+"' ";
			}else{
				condition123 += "`password`='"+password+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria orPasswordEquals(String password){
		if(password!=null&&password.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `password`='"+password+"' ";
			}else{
				condition123 += "`password`='"+password+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andPasswordNotEquals(String password){
		if(password!=null&&password.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `password`!='"+password+"' ";
			}else{
				condition123 += "`password`!='"+password+"' ";
			}
		}
		return this;
	}
	public UserCriteria orPasswordNotEquals(String password){
		if(password!=null&&password.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `password`!='"+password+"' ";
			}else{
				condition123 += "`password`!='"+password+"' ";
			}
		}
		return this;
	}
	/**
	 * 大于
	 * @param 
	 * @return
	 */
	public UserCriteria andPasswordGreaterThan(String password){
		if(password!=null&&password.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `password`>'"+password+"' ";
			}else{
				condition123 += "`password`>'"+password+"' ";
			}
		}
		return this;
	}
	public UserCriteria orPasswordGreaterThan(String password){
		if(password!=null&&password.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `password`>'"+password+"' ";
			}else{
				condition123 += "`password`>'"+password+"' ";
			}
		}
		return this;
	}
	
	
	public UserCriteria andPasswordLessThan(String password){
		if(password!=null&&password.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `password`<'"+password+"' ";
			}else{
				condition123 += "`password`<'"+password+"' ";
			}
		}
		return this;
	}
	public UserCriteria orPasswordLessThan(String password){
		if(password!=null&&password.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `password`<'"+password+"' ";
			}else{
				condition123 += "`password`<'"+password+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andPasswordGreadterThanAndEquals(String password){
		if(password!=null&&password.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `password`>='"+password+"' ";
			}else{
				condition123 += "`password`>='"+password+"' ";
			}
		}
		return this;
	}
	public UserCriteria orPasswordGreadterThanAndEquals(String password){
		if(password!=null&&password.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `password`>='"+password+"' ";
			}else{
				condition123 += "`password`>='"+password+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andPasswordLessThanAndEquals(String password){
		if(password!=null&&password.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `password`<='"+password+"' ";
			}else{
				condition123 += "`password`<='"+password+"' ";
			}
		}
		return this;
	}
	public UserCriteria orPasswordLessThanAndEquals(String password){
		if(password!=null&&password.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `password`<='"+password+"' ";
			}else{
				condition123 += "`password`<='"+password+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andPasswordLike(String password){
		if(password!=null&&password.trim().length()>0&&!("%".equals(password.trim()))&&!("%%".equals(password.trim()))){
			if(condition123.length()>0){
				condition123 += "and `password` like '"+password+"' ";
			}else{
				condition123 += "`password` like '"+password+"' ";
			}
		}
		return this;
	}
	public UserCriteria orPasswordLike(String password){
		if(password!=null&&password.trim().length()>0&&!("%".equals(password.trim()))&&!("%%".equals(password.trim()))){
			if(condition123.length()>0){
				condition123 += "or `password` like '"+password+"' ";
			}else{
				condition123 += "`password` like '"+password+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andPasswordIsNull(){
			if(condition123.length()>0){
				condition123 += "and `password` is null";
			}else{
				condition123 += "`password` is null";
			}
		return this;
	}
	public UserCriteria orPasswordIsNull(){
		if(condition123.length()>0){
			condition123 += "or `password` is null";
		}else{
			condition123 += "`password` is null";
		}
		return this;
	}
	public UserCriteria andPasswordIsNotNull(){
		if(condition123.length()>0){
			condition123 += "and `password` is not null";
		}else{
			condition123 += "`password` is not null";
		}
		return this;
	}
	public UserCriteria orPasswordIsNotNull(){
		if(condition123.length()>0){
			condition123 += "or `password` is not null";
		}else{
			condition123 += "`password` is not null";
		}
		return this;
	}
	
	public UserCriteria andPasswordIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `password` in("+value+") ";
			}else{
				condition123 += "`password` in("+value+") ";
			}
		}
		return this;
	}
	
	public UserCriteria orPasswordIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `password` in("+value+") ";
			}else{
				condition123 += "`password` in("+value+") ";
			}
		}
		return this;
	}
	
	public UserCriteria andPasswordNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `password` not in("+value+") ";
			}else{
				condition123 += "`password` not in("+value+") ";
			}
		}
		return this;
	}
	
	public UserCriteria orPasswordNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `password` not in("+value+") ";
			}else{
				condition123 += "`password` not in("+value+") ";
			}
		}
		return this;
	}

	public UserCriteria andNickNameEquals(String nickName){
		if(nickName!=null&&nickName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `nick_name`='"+nickName+"' ";
			}else{
				condition123 += "`nick_name`='"+nickName+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria orNickNameEquals(String nickName){
		if(nickName!=null&&nickName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `nick_name`='"+nickName+"' ";
			}else{
				condition123 += "`nick_name`='"+nickName+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andNickNameNotEquals(String nickName){
		if(nickName!=null&&nickName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `nick_name`!='"+nickName+"' ";
			}else{
				condition123 += "`nick_name`!='"+nickName+"' ";
			}
		}
		return this;
	}
	public UserCriteria orNickNameNotEquals(String nickName){
		if(nickName!=null&&nickName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `nick_name`!='"+nickName+"' ";
			}else{
				condition123 += "`nick_name`!='"+nickName+"' ";
			}
		}
		return this;
	}
	/**
	 * 大于
	 * @param 
	 * @return
	 */
	public UserCriteria andNickNameGreaterThan(String nickName){
		if(nickName!=null&&nickName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `nick_name`>'"+nickName+"' ";
			}else{
				condition123 += "`nick_name`>'"+nickName+"' ";
			}
		}
		return this;
	}
	public UserCriteria orNickNameGreaterThan(String nickName){
		if(nickName!=null&&nickName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `nick_name`>'"+nickName+"' ";
			}else{
				condition123 += "`nick_name`>'"+nickName+"' ";
			}
		}
		return this;
	}
	
	
	public UserCriteria andNickNameLessThan(String nickName){
		if(nickName!=null&&nickName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `nick_name`<'"+nickName+"' ";
			}else{
				condition123 += "`nick_name`<'"+nickName+"' ";
			}
		}
		return this;
	}
	public UserCriteria orNickNameLessThan(String nickName){
		if(nickName!=null&&nickName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `nick_name`<'"+nickName+"' ";
			}else{
				condition123 += "`nick_name`<'"+nickName+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andNickNameGreadterThanAndEquals(String nickName){
		if(nickName!=null&&nickName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `nick_name`>='"+nickName+"' ";
			}else{
				condition123 += "`nick_name`>='"+nickName+"' ";
			}
		}
		return this;
	}
	public UserCriteria orNickNameGreadterThanAndEquals(String nickName){
		if(nickName!=null&&nickName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `nick_name`>='"+nickName+"' ";
			}else{
				condition123 += "`nick_name`>='"+nickName+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andNickNameLessThanAndEquals(String nickName){
		if(nickName!=null&&nickName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `nick_name`<='"+nickName+"' ";
			}else{
				condition123 += "`nick_name`<='"+nickName+"' ";
			}
		}
		return this;
	}
	public UserCriteria orNickNameLessThanAndEquals(String nickName){
		if(nickName!=null&&nickName.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `nick_name`<='"+nickName+"' ";
			}else{
				condition123 += "`nick_name`<='"+nickName+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andNickNameLike(String nickName){
		if(nickName!=null&&nickName.trim().length()>0&&!("%".equals(nickName.trim()))&&!("%%".equals(nickName.trim()))){
			if(condition123.length()>0){
				condition123 += "and `nick_name` like '"+nickName+"' ";
			}else{
				condition123 += "`nick_name` like '"+nickName+"' ";
			}
		}
		return this;
	}
	public UserCriteria orNickNameLike(String nickName){
		if(nickName!=null&&nickName.trim().length()>0&&!("%".equals(nickName.trim()))&&!("%%".equals(nickName.trim()))){
			if(condition123.length()>0){
				condition123 += "or `nick_name` like '"+nickName+"' ";
			}else{
				condition123 += "`nick_name` like '"+nickName+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andNickNameIsNull(){
			if(condition123.length()>0){
				condition123 += "and `nick_name` is null";
			}else{
				condition123 += "`nick_name` is null";
			}
		return this;
	}
	public UserCriteria orNickNameIsNull(){
		if(condition123.length()>0){
			condition123 += "or `nick_name` is null";
		}else{
			condition123 += "`nick_name` is null";
		}
		return this;
	}
	public UserCriteria andNickNameIsNotNull(){
		if(condition123.length()>0){
			condition123 += "and `nick_name` is not null";
		}else{
			condition123 += "`nick_name` is not null";
		}
		return this;
	}
	public UserCriteria orNickNameIsNotNull(){
		if(condition123.length()>0){
			condition123 += "or `nick_name` is not null";
		}else{
			condition123 += "`nick_name` is not null";
		}
		return this;
	}
	
	public UserCriteria andNickNameIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `nick_name` in("+value+") ";
			}else{
				condition123 += "`nick_name` in("+value+") ";
			}
		}
		return this;
	}
	
	public UserCriteria orNickNameIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `nick_name` in("+value+") ";
			}else{
				condition123 += "`nick_name` in("+value+") ";
			}
		}
		return this;
	}
	
	public UserCriteria andNickNameNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `nick_name` not in("+value+") ";
			}else{
				condition123 += "`nick_name` not in("+value+") ";
			}
		}
		return this;
	}
	
	public UserCriteria orNickNameNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `nick_name` not in("+value+") ";
			}else{
				condition123 += "`nick_name` not in("+value+") ";
			}
		}
		return this;
	}

	public UserCriteria andCountryEquals(String country){
		if(country!=null&&country.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `country`='"+country+"' ";
			}else{
				condition123 += "`country`='"+country+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria orCountryEquals(String country){
		if(country!=null&&country.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `country`='"+country+"' ";
			}else{
				condition123 += "`country`='"+country+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andCountryNotEquals(String country){
		if(country!=null&&country.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `country`!='"+country+"' ";
			}else{
				condition123 += "`country`!='"+country+"' ";
			}
		}
		return this;
	}
	public UserCriteria orCountryNotEquals(String country){
		if(country!=null&&country.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `country`!='"+country+"' ";
			}else{
				condition123 += "`country`!='"+country+"' ";
			}
		}
		return this;
	}
	/**
	 * 大于
	 * @param 
	 * @return
	 */
	public UserCriteria andCountryGreaterThan(String country){
		if(country!=null&&country.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `country`>'"+country+"' ";
			}else{
				condition123 += "`country`>'"+country+"' ";
			}
		}
		return this;
	}
	public UserCriteria orCountryGreaterThan(String country){
		if(country!=null&&country.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `country`>'"+country+"' ";
			}else{
				condition123 += "`country`>'"+country+"' ";
			}
		}
		return this;
	}
	
	
	public UserCriteria andCountryLessThan(String country){
		if(country!=null&&country.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `country`<'"+country+"' ";
			}else{
				condition123 += "`country`<'"+country+"' ";
			}
		}
		return this;
	}
	public UserCriteria orCountryLessThan(String country){
		if(country!=null&&country.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `country`<'"+country+"' ";
			}else{
				condition123 += "`country`<'"+country+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andCountryGreadterThanAndEquals(String country){
		if(country!=null&&country.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `country`>='"+country+"' ";
			}else{
				condition123 += "`country`>='"+country+"' ";
			}
		}
		return this;
	}
	public UserCriteria orCountryGreadterThanAndEquals(String country){
		if(country!=null&&country.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `country`>='"+country+"' ";
			}else{
				condition123 += "`country`>='"+country+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andCountryLessThanAndEquals(String country){
		if(country!=null&&country.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `country`<='"+country+"' ";
			}else{
				condition123 += "`country`<='"+country+"' ";
			}
		}
		return this;
	}
	public UserCriteria orCountryLessThanAndEquals(String country){
		if(country!=null&&country.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `country`<='"+country+"' ";
			}else{
				condition123 += "`country`<='"+country+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andCountryLike(String country){
		if(country!=null&&country.trim().length()>0&&!("%".equals(country.trim()))&&!("%%".equals(country.trim()))){
			if(condition123.length()>0){
				condition123 += "and `country` like '"+country+"' ";
			}else{
				condition123 += "`country` like '"+country+"' ";
			}
		}
		return this;
	}
	public UserCriteria orCountryLike(String country){
		if(country!=null&&country.trim().length()>0&&!("%".equals(country.trim()))&&!("%%".equals(country.trim()))){
			if(condition123.length()>0){
				condition123 += "or `country` like '"+country+"' ";
			}else{
				condition123 += "`country` like '"+country+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andCountryIsNull(){
			if(condition123.length()>0){
				condition123 += "and `country` is null";
			}else{
				condition123 += "`country` is null";
			}
		return this;
	}
	public UserCriteria orCountryIsNull(){
		if(condition123.length()>0){
			condition123 += "or `country` is null";
		}else{
			condition123 += "`country` is null";
		}
		return this;
	}
	public UserCriteria andCountryIsNotNull(){
		if(condition123.length()>0){
			condition123 += "and `country` is not null";
		}else{
			condition123 += "`country` is not null";
		}
		return this;
	}
	public UserCriteria orCountryIsNotNull(){
		if(condition123.length()>0){
			condition123 += "or `country` is not null";
		}else{
			condition123 += "`country` is not null";
		}
		return this;
	}
	
	public UserCriteria andCountryIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `country` in("+value+") ";
			}else{
				condition123 += "`country` in("+value+") ";
			}
		}
		return this;
	}
	
	public UserCriteria orCountryIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `country` in("+value+") ";
			}else{
				condition123 += "`country` in("+value+") ";
			}
		}
		return this;
	}
	
	public UserCriteria andCountryNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `country` not in("+value+") ";
			}else{
				condition123 += "`country` not in("+value+") ";
			}
		}
		return this;
	}
	
	public UserCriteria orCountryNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `country` not in("+value+") ";
			}else{
				condition123 += "`country` not in("+value+") ";
			}
		}
		return this;
	}

	public UserCriteria andPhoneEquals(String phone){
		if(phone!=null&&phone.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `phone`='"+phone+"' ";
			}else{
				condition123 += "`phone`='"+phone+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria orPhoneEquals(String phone){
		if(phone!=null&&phone.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `phone`='"+phone+"' ";
			}else{
				condition123 += "`phone`='"+phone+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andPhoneNotEquals(String phone){
		if(phone!=null&&phone.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `phone`!='"+phone+"' ";
			}else{
				condition123 += "`phone`!='"+phone+"' ";
			}
		}
		return this;
	}
	public UserCriteria orPhoneNotEquals(String phone){
		if(phone!=null&&phone.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `phone`!='"+phone+"' ";
			}else{
				condition123 += "`phone`!='"+phone+"' ";
			}
		}
		return this;
	}
	/**
	 * 大于
	 * @param 
	 * @return
	 */
	public UserCriteria andPhoneGreaterThan(String phone){
		if(phone!=null&&phone.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `phone`>'"+phone+"' ";
			}else{
				condition123 += "`phone`>'"+phone+"' ";
			}
		}
		return this;
	}
	public UserCriteria orPhoneGreaterThan(String phone){
		if(phone!=null&&phone.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `phone`>'"+phone+"' ";
			}else{
				condition123 += "`phone`>'"+phone+"' ";
			}
		}
		return this;
	}
	
	
	public UserCriteria andPhoneLessThan(String phone){
		if(phone!=null&&phone.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `phone`<'"+phone+"' ";
			}else{
				condition123 += "`phone`<'"+phone+"' ";
			}
		}
		return this;
	}
	public UserCriteria orPhoneLessThan(String phone){
		if(phone!=null&&phone.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `phone`<'"+phone+"' ";
			}else{
				condition123 += "`phone`<'"+phone+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andPhoneGreadterThanAndEquals(String phone){
		if(phone!=null&&phone.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `phone`>='"+phone+"' ";
			}else{
				condition123 += "`phone`>='"+phone+"' ";
			}
		}
		return this;
	}
	public UserCriteria orPhoneGreadterThanAndEquals(String phone){
		if(phone!=null&&phone.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `phone`>='"+phone+"' ";
			}else{
				condition123 += "`phone`>='"+phone+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andPhoneLessThanAndEquals(String phone){
		if(phone!=null&&phone.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `phone`<='"+phone+"' ";
			}else{
				condition123 += "`phone`<='"+phone+"' ";
			}
		}
		return this;
	}
	public UserCriteria orPhoneLessThanAndEquals(String phone){
		if(phone!=null&&phone.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `phone`<='"+phone+"' ";
			}else{
				condition123 += "`phone`<='"+phone+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andPhoneLike(String phone){
		if(phone!=null&&phone.trim().length()>0&&!("%".equals(phone.trim()))&&!("%%".equals(phone.trim()))){
			if(condition123.length()>0){
				condition123 += "and `phone` like '"+phone+"' ";
			}else{
				condition123 += "`phone` like '"+phone+"' ";
			}
		}
		return this;
	}
	public UserCriteria orPhoneLike(String phone){
		if(phone!=null&&phone.trim().length()>0&&!("%".equals(phone.trim()))&&!("%%".equals(phone.trim()))){
			if(condition123.length()>0){
				condition123 += "or `phone` like '"+phone+"' ";
			}else{
				condition123 += "`phone` like '"+phone+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andPhoneIsNull(){
			if(condition123.length()>0){
				condition123 += "and `phone` is null";
			}else{
				condition123 += "`phone` is null";
			}
		return this;
	}
	public UserCriteria orPhoneIsNull(){
		if(condition123.length()>0){
			condition123 += "or `phone` is null";
		}else{
			condition123 += "`phone` is null";
		}
		return this;
	}
	public UserCriteria andPhoneIsNotNull(){
		if(condition123.length()>0){
			condition123 += "and `phone` is not null";
		}else{
			condition123 += "`phone` is not null";
		}
		return this;
	}
	public UserCriteria orPhoneIsNotNull(){
		if(condition123.length()>0){
			condition123 += "or `phone` is not null";
		}else{
			condition123 += "`phone` is not null";
		}
		return this;
	}
	
	public UserCriteria andPhoneIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `phone` in("+value+") ";
			}else{
				condition123 += "`phone` in("+value+") ";
			}
		}
		return this;
	}
	
	public UserCriteria orPhoneIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `phone` in("+value+") ";
			}else{
				condition123 += "`phone` in("+value+") ";
			}
		}
		return this;
	}
	
	public UserCriteria andPhoneNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `phone` not in("+value+") ";
			}else{
				condition123 += "`phone` not in("+value+") ";
			}
		}
		return this;
	}
	
	public UserCriteria orPhoneNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `phone` not in("+value+") ";
			}else{
				condition123 += "`phone` not in("+value+") ";
			}
		}
		return this;
	}

	public UserCriteria andHeadImgEquals(String headImg){
		if(headImg!=null&&headImg.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `head_img`='"+headImg+"' ";
			}else{
				condition123 += "`head_img`='"+headImg+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria orHeadImgEquals(String headImg){
		if(headImg!=null&&headImg.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `head_img`='"+headImg+"' ";
			}else{
				condition123 += "`head_img`='"+headImg+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andHeadImgNotEquals(String headImg){
		if(headImg!=null&&headImg.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `head_img`!='"+headImg+"' ";
			}else{
				condition123 += "`head_img`!='"+headImg+"' ";
			}
		}
		return this;
	}
	public UserCriteria orHeadImgNotEquals(String headImg){
		if(headImg!=null&&headImg.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `head_img`!='"+headImg+"' ";
			}else{
				condition123 += "`head_img`!='"+headImg+"' ";
			}
		}
		return this;
	}
	/**
	 * 大于
	 * @param 
	 * @return
	 */
	public UserCriteria andHeadImgGreaterThan(String headImg){
		if(headImg!=null&&headImg.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `head_img`>'"+headImg+"' ";
			}else{
				condition123 += "`head_img`>'"+headImg+"' ";
			}
		}
		return this;
	}
	public UserCriteria orHeadImgGreaterThan(String headImg){
		if(headImg!=null&&headImg.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `head_img`>'"+headImg+"' ";
			}else{
				condition123 += "`head_img`>'"+headImg+"' ";
			}
		}
		return this;
	}
	
	
	public UserCriteria andHeadImgLessThan(String headImg){
		if(headImg!=null&&headImg.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `head_img`<'"+headImg+"' ";
			}else{
				condition123 += "`head_img`<'"+headImg+"' ";
			}
		}
		return this;
	}
	public UserCriteria orHeadImgLessThan(String headImg){
		if(headImg!=null&&headImg.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `head_img`<'"+headImg+"' ";
			}else{
				condition123 += "`head_img`<'"+headImg+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andHeadImgGreadterThanAndEquals(String headImg){
		if(headImg!=null&&headImg.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `head_img`>='"+headImg+"' ";
			}else{
				condition123 += "`head_img`>='"+headImg+"' ";
			}
		}
		return this;
	}
	public UserCriteria orHeadImgGreadterThanAndEquals(String headImg){
		if(headImg!=null&&headImg.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `head_img`>='"+headImg+"' ";
			}else{
				condition123 += "`head_img`>='"+headImg+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andHeadImgLessThanAndEquals(String headImg){
		if(headImg!=null&&headImg.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `head_img`<='"+headImg+"' ";
			}else{
				condition123 += "`head_img`<='"+headImg+"' ";
			}
		}
		return this;
	}
	public UserCriteria orHeadImgLessThanAndEquals(String headImg){
		if(headImg!=null&&headImg.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `head_img`<='"+headImg+"' ";
			}else{
				condition123 += "`head_img`<='"+headImg+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andHeadImgLike(String headImg){
		if(headImg!=null&&headImg.trim().length()>0&&!("%".equals(headImg.trim()))&&!("%%".equals(headImg.trim()))){
			if(condition123.length()>0){
				condition123 += "and `head_img` like '"+headImg+"' ";
			}else{
				condition123 += "`head_img` like '"+headImg+"' ";
			}
		}
		return this;
	}
	public UserCriteria orHeadImgLike(String headImg){
		if(headImg!=null&&headImg.trim().length()>0&&!("%".equals(headImg.trim()))&&!("%%".equals(headImg.trim()))){
			if(condition123.length()>0){
				condition123 += "or `head_img` like '"+headImg+"' ";
			}else{
				condition123 += "`head_img` like '"+headImg+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andHeadImgIsNull(){
			if(condition123.length()>0){
				condition123 += "and `head_img` is null";
			}else{
				condition123 += "`head_img` is null";
			}
		return this;
	}
	public UserCriteria orHeadImgIsNull(){
		if(condition123.length()>0){
			condition123 += "or `head_img` is null";
		}else{
			condition123 += "`head_img` is null";
		}
		return this;
	}
	public UserCriteria andHeadImgIsNotNull(){
		if(condition123.length()>0){
			condition123 += "and `head_img` is not null";
		}else{
			condition123 += "`head_img` is not null";
		}
		return this;
	}
	public UserCriteria orHeadImgIsNotNull(){
		if(condition123.length()>0){
			condition123 += "or `head_img` is not null";
		}else{
			condition123 += "`head_img` is not null";
		}
		return this;
	}
	
	public UserCriteria andHeadImgIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `head_img` in("+value+") ";
			}else{
				condition123 += "`head_img` in("+value+") ";
			}
		}
		return this;
	}
	
	public UserCriteria orHeadImgIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `head_img` in("+value+") ";
			}else{
				condition123 += "`head_img` in("+value+") ";
			}
		}
		return this;
	}
	
	public UserCriteria andHeadImgNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `head_img` not in("+value+") ";
			}else{
				condition123 += "`head_img` not in("+value+") ";
			}
		}
		return this;
	}
	
	public UserCriteria orHeadImgNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `head_img` not in("+value+") ";
			}else{
				condition123 += "`head_img` not in("+value+") ";
			}
		}
		return this;
	}

	public UserCriteria andEmilEquals(String emil){
		if(emil!=null&&emil.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `emil`='"+emil+"' ";
			}else{
				condition123 += "`emil`='"+emil+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria orEmilEquals(String emil){
		if(emil!=null&&emil.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `emil`='"+emil+"' ";
			}else{
				condition123 += "`emil`='"+emil+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andEmilNotEquals(String emil){
		if(emil!=null&&emil.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `emil`!='"+emil+"' ";
			}else{
				condition123 += "`emil`!='"+emil+"' ";
			}
		}
		return this;
	}
	public UserCriteria orEmilNotEquals(String emil){
		if(emil!=null&&emil.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `emil`!='"+emil+"' ";
			}else{
				condition123 += "`emil`!='"+emil+"' ";
			}
		}
		return this;
	}
	/**
	 * 大于
	 * @param 
	 * @return
	 */
	public UserCriteria andEmilGreaterThan(String emil){
		if(emil!=null&&emil.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `emil`>'"+emil+"' ";
			}else{
				condition123 += "`emil`>'"+emil+"' ";
			}
		}
		return this;
	}
	public UserCriteria orEmilGreaterThan(String emil){
		if(emil!=null&&emil.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `emil`>'"+emil+"' ";
			}else{
				condition123 += "`emil`>'"+emil+"' ";
			}
		}
		return this;
	}
	
	
	public UserCriteria andEmilLessThan(String emil){
		if(emil!=null&&emil.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `emil`<'"+emil+"' ";
			}else{
				condition123 += "`emil`<'"+emil+"' ";
			}
		}
		return this;
	}
	public UserCriteria orEmilLessThan(String emil){
		if(emil!=null&&emil.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `emil`<'"+emil+"' ";
			}else{
				condition123 += "`emil`<'"+emil+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andEmilGreadterThanAndEquals(String emil){
		if(emil!=null&&emil.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `emil`>='"+emil+"' ";
			}else{
				condition123 += "`emil`>='"+emil+"' ";
			}
		}
		return this;
	}
	public UserCriteria orEmilGreadterThanAndEquals(String emil){
		if(emil!=null&&emil.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `emil`>='"+emil+"' ";
			}else{
				condition123 += "`emil`>='"+emil+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andEmilLessThanAndEquals(String emil){
		if(emil!=null&&emil.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `emil`<='"+emil+"' ";
			}else{
				condition123 += "`emil`<='"+emil+"' ";
			}
		}
		return this;
	}
	public UserCriteria orEmilLessThanAndEquals(String emil){
		if(emil!=null&&emil.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `emil`<='"+emil+"' ";
			}else{
				condition123 += "`emil`<='"+emil+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andEmilLike(String emil){
		if(emil!=null&&emil.trim().length()>0&&!("%".equals(emil.trim()))&&!("%%".equals(emil.trim()))){
			if(condition123.length()>0){
				condition123 += "and `emil` like '"+emil+"' ";
			}else{
				condition123 += "`emil` like '"+emil+"' ";
			}
		}
		return this;
	}
	public UserCriteria orEmilLike(String emil){
		if(emil!=null&&emil.trim().length()>0&&!("%".equals(emil.trim()))&&!("%%".equals(emil.trim()))){
			if(condition123.length()>0){
				condition123 += "or `emil` like '"+emil+"' ";
			}else{
				condition123 += "`emil` like '"+emil+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andEmilIsNull(){
			if(condition123.length()>0){
				condition123 += "and `emil` is null";
			}else{
				condition123 += "`emil` is null";
			}
		return this;
	}
	public UserCriteria orEmilIsNull(){
		if(condition123.length()>0){
			condition123 += "or `emil` is null";
		}else{
			condition123 += "`emil` is null";
		}
		return this;
	}
	public UserCriteria andEmilIsNotNull(){
		if(condition123.length()>0){
			condition123 += "and `emil` is not null";
		}else{
			condition123 += "`emil` is not null";
		}
		return this;
	}
	public UserCriteria orEmilIsNotNull(){
		if(condition123.length()>0){
			condition123 += "or `emil` is not null";
		}else{
			condition123 += "`emil` is not null";
		}
		return this;
	}
	
	public UserCriteria andEmilIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `emil` in("+value+") ";
			}else{
				condition123 += "`emil` in("+value+") ";
			}
		}
		return this;
	}
	
	public UserCriteria orEmilIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `emil` in("+value+") ";
			}else{
				condition123 += "`emil` in("+value+") ";
			}
		}
		return this;
	}
	
	public UserCriteria andEmilNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `emil` not in("+value+") ";
			}else{
				condition123 += "`emil` not in("+value+") ";
			}
		}
		return this;
	}
	
	public UserCriteria orEmilNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `emil` not in("+value+") ";
			}else{
				condition123 += "`emil` not in("+value+") ";
			}
		}
		return this;
	}

	public UserCriteria andCreateDateEquals(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `create_date`='"+createDate+"' ";
			}else{
				condition123 += "`create_date`='"+createDate+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria orCreateDateEquals(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `create_date`='"+createDate+"' ";
			}else{
				condition123 += "`create_date`='"+createDate+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andCreateDateNotEquals(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `create_date`!='"+createDate+"' ";
			}else{
				condition123 += "`create_date`!='"+createDate+"' ";
			}
		}
		return this;
	}
	public UserCriteria orCreateDateNotEquals(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `create_date`!='"+createDate+"' ";
			}else{
				condition123 += "`create_date`!='"+createDate+"' ";
			}
		}
		return this;
	}
	/**
	 * 大于
	 * @param 
	 * @return
	 */
	public UserCriteria andCreateDateGreaterThan(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `create_date`>'"+createDate+"' ";
			}else{
				condition123 += "`create_date`>'"+createDate+"' ";
			}
		}
		return this;
	}
	public UserCriteria orCreateDateGreaterThan(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `create_date`>'"+createDate+"' ";
			}else{
				condition123 += "`create_date`>'"+createDate+"' ";
			}
		}
		return this;
	}
	
	
	public UserCriteria andCreateDateLessThan(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `create_date`<'"+createDate+"' ";
			}else{
				condition123 += "`create_date`<'"+createDate+"' ";
			}
		}
		return this;
	}
	public UserCriteria orCreateDateLessThan(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `create_date`<'"+createDate+"' ";
			}else{
				condition123 += "`create_date`<'"+createDate+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andCreateDateGreadterThanAndEquals(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `create_date`>='"+createDate+"' ";
			}else{
				condition123 += "`create_date`>='"+createDate+"' ";
			}
		}
		return this;
	}
	public UserCriteria orCreateDateGreadterThanAndEquals(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `create_date`>='"+createDate+"' ";
			}else{
				condition123 += "`create_date`>='"+createDate+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andCreateDateLessThanAndEquals(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `create_date`<='"+createDate+"' ";
			}else{
				condition123 += "`create_date`<='"+createDate+"' ";
			}
		}
		return this;
	}
	public UserCriteria orCreateDateLessThanAndEquals(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `create_date`<='"+createDate+"' ";
			}else{
				condition123 += "`create_date`<='"+createDate+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andCreateDateLike(String createDate){
		if(createDate!=null&&createDate.trim().length()>0&&!("%".equals(createDate.trim()))&&!("%%".equals(createDate.trim()))){
			if(condition123.length()>0){
				condition123 += "and `create_date` like '"+createDate+"' ";
			}else{
				condition123 += "`create_date` like '"+createDate+"' ";
			}
		}
		return this;
	}
	public UserCriteria orCreateDateLike(String createDate){
		if(createDate!=null&&createDate.trim().length()>0&&!("%".equals(createDate.trim()))&&!("%%".equals(createDate.trim()))){
			if(condition123.length()>0){
				condition123 += "or `create_date` like '"+createDate+"' ";
			}else{
				condition123 += "`create_date` like '"+createDate+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andCreateDateIsNull(){
			if(condition123.length()>0){
				condition123 += "and `create_date` is null";
			}else{
				condition123 += "`create_date` is null";
			}
		return this;
	}
	public UserCriteria orCreateDateIsNull(){
		if(condition123.length()>0){
			condition123 += "or `create_date` is null";
		}else{
			condition123 += "`create_date` is null";
		}
		return this;
	}
	public UserCriteria andCreateDateIsNotNull(){
		if(condition123.length()>0){
			condition123 += "and `create_date` is not null";
		}else{
			condition123 += "`create_date` is not null";
		}
		return this;
	}
	public UserCriteria orCreateDateIsNotNull(){
		if(condition123.length()>0){
			condition123 += "or `create_date` is not null";
		}else{
			condition123 += "`create_date` is not null";
		}
		return this;
	}
	
	public UserCriteria andCreateDateIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `create_date` in("+value+") ";
			}else{
				condition123 += "`create_date` in("+value+") ";
			}
		}
		return this;
	}
	
	public UserCriteria orCreateDateIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `create_date` in("+value+") ";
			}else{
				condition123 += "`create_date` in("+value+") ";
			}
		}
		return this;
	}
	
	public UserCriteria andCreateDateNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `create_date` not in("+value+") ";
			}else{
				condition123 += "`create_date` not in("+value+") ";
			}
		}
		return this;
	}
	
	public UserCriteria orCreateDateNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `create_date` not in("+value+") ";
			}else{
				condition123 += "`create_date` not in("+value+") ";
			}
		}
		return this;
	}

	public UserCriteria andStateEquals(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `state`='"+state+"' ";
			}else{
				condition123 += "`state`='"+state+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria orStateEquals(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `state`='"+state+"' ";
			}else{
				condition123 += "`state`='"+state+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andStateNotEquals(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `state`!='"+state+"' ";
			}else{
				condition123 += "`state`!='"+state+"' ";
			}
		}
		return this;
	}
	public UserCriteria orStateNotEquals(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `state`!='"+state+"' ";
			}else{
				condition123 += "`state`!='"+state+"' ";
			}
		}
		return this;
	}
	/**
	 * 大于
	 * @param 
	 * @return
	 */
	public UserCriteria andStateGreaterThan(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `state`>'"+state+"' ";
			}else{
				condition123 += "`state`>'"+state+"' ";
			}
		}
		return this;
	}
	public UserCriteria orStateGreaterThan(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `state`>'"+state+"' ";
			}else{
				condition123 += "`state`>'"+state+"' ";
			}
		}
		return this;
	}
	
	
	public UserCriteria andStateLessThan(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `state`<'"+state+"' ";
			}else{
				condition123 += "`state`<'"+state+"' ";
			}
		}
		return this;
	}
	public UserCriteria orStateLessThan(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `state`<'"+state+"' ";
			}else{
				condition123 += "`state`<'"+state+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andStateGreadterThanAndEquals(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `state`>='"+state+"' ";
			}else{
				condition123 += "`state`>='"+state+"' ";
			}
		}
		return this;
	}
	public UserCriteria orStateGreadterThanAndEquals(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `state`>='"+state+"' ";
			}else{
				condition123 += "`state`>='"+state+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andStateLessThanAndEquals(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `state`<='"+state+"' ";
			}else{
				condition123 += "`state`<='"+state+"' ";
			}
		}
		return this;
	}
	public UserCriteria orStateLessThanAndEquals(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `state`<='"+state+"' ";
			}else{
				condition123 += "`state`<='"+state+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andStateLike(String state){
		if(state!=null&&state.trim().length()>0&&!("%".equals(state.trim()))&&!("%%".equals(state.trim()))){
			if(condition123.length()>0){
				condition123 += "and `state` like '"+state+"' ";
			}else{
				condition123 += "`state` like '"+state+"' ";
			}
		}
		return this;
	}
	public UserCriteria orStateLike(String state){
		if(state!=null&&state.trim().length()>0&&!("%".equals(state.trim()))&&!("%%".equals(state.trim()))){
			if(condition123.length()>0){
				condition123 += "or `state` like '"+state+"' ";
			}else{
				condition123 += "`state` like '"+state+"' ";
			}
		}
		return this;
	}
	
	public UserCriteria andStateIsNull(){
			if(condition123.length()>0){
				condition123 += "and `state` is null";
			}else{
				condition123 += "`state` is null";
			}
		return this;
	}
	public UserCriteria orStateIsNull(){
		if(condition123.length()>0){
			condition123 += "or `state` is null";
		}else{
			condition123 += "`state` is null";
		}
		return this;
	}
	public UserCriteria andStateIsNotNull(){
		if(condition123.length()>0){
			condition123 += "and `state` is not null";
		}else{
			condition123 += "`state` is not null";
		}
		return this;
	}
	public UserCriteria orStateIsNotNull(){
		if(condition123.length()>0){
			condition123 += "or `state` is not null";
		}else{
			condition123 += "`state` is not null";
		}
		return this;
	}
	
	public UserCriteria andStateIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `state` in("+value+") ";
			}else{
				condition123 += "`state` in("+value+") ";
			}
		}
		return this;
	}
	
	public UserCriteria orStateIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `state` in("+value+") ";
			}else{
				condition123 += "`state` in("+value+") ";
			}
		}
		return this;
	}
	
	public UserCriteria andStateNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `state` not in("+value+") ";
			}else{
				condition123 += "`state` not in("+value+") ";
			}
		}
		return this;
	}
	
	public UserCriteria orStateNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `state` not in("+value+") ";
			}else{
				condition123 += "`state` not in("+value+") ";
			}
		}
		return this;
	}

	private void initUser(User user) {
		super.setId(user.getId());
		super.setUserName(user.getUserName());
		super.setPassword(user.getPassword());
		super.setNickName(user.getNickName());
		super.setCountry(user.getCountry());
		super.setPhone(user.getPhone());
		super.setHeadImg(user.getHeadImg());
		super.setEmil(user.getEmil());
		super.setCreateDate(user.getCreateDate());
		super.setState(user.getState());

	}

}